<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreateYbzUserinfoTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
      Schema::create('nw_ybz_userinfo', function (Blueprint $table) {
        $table->id()->comment('序号');
        $table->string('resource_name')->unique()->comment('资源集名称')->nullable(false);
        $table->string('vdc_level')->nullable()->comment('VDC级别');
        $table->string('used_component')->nullable()->comment('所用组件');
        $table->string('system_id')->nullable()->comment('系统编号');
        $table->string('unified_cloud_report')->nullable()->comment('统一云管上报');
        $table->string('resource_application_time')->nullable()->comment('申请资源时间');
        $table->string('deployment_time')->nullable()->comment('部署时间');
        $table->string('online_time')->nullable()->comment('上线时间');
        $table->string('project_management_account')->nullable()->comment('项目管理账号');
        $table->boolean('account_received')->nullable()->comment('是否领取账号');
        $table->string('account_user')->nullable()->comment('账号使用人');
        $table->string('account_user_phone')->nullable()->comment('账号使用人电话');
        $table->string('role')->nullable()->comment('角色');
        $table->string('purpose')->nullable()->comment('用途');
        $table->string('self_built_or_push')->nullable()->comment('自建/统推');
        $table->string('running_or_deployment')->nullable()->comment('运行/部署');
        $table->text('description')->nullable()->comment('说明');
        $table->string('specialist')->nullable()->comment('专责');
        $table->string('specialist_email')->nullable()->comment('专责邮箱');
        $table->string('specialist_phone')->nullable()->comment('专责电话');
        $table->string('project_manager')->nullable()->comment('项目经理');
        $table->string('project_manager_phone')->nullable()->comment('项目经理电话');
        $table->string('project_manager_email')->nullable()->comment('项目经理邮箱');
        $table->string('maintenance_personnel')->nullable()->comment('运维人员');
        $table->string('maintenance_phone')->nullable()->comment('电话');
        $table->string('project_team_email')->nullable()->comment('项目组邮箱');
        $table->timestamps();
    });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('nw_ybz_userinfo');
    }
}
